| SaGLRelease |
| Logical Entity Name | SaGLRelease |
| Default Table Name | SaGLRelease |
| Physical Only | NO |
| Definition | |
| Note |
| SaGLRelease Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaGLReleaseID |
int | NO | ||
| SaTransID | int | YES | ||
| SaRevenueDetailID | int | YES | ||
| BatchNo | char(8) | NO | ||
| TransDate | datetime | YES | ||
| AccountNumber | nvarchar(100) | NO | ||
| DebitAmount | money | NO | ||
| CreditAmount | money | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| UserID | int | NO | ||
| ts | timestamp | NO | ||
| Descrip | varchar(50) | YES | ||
| GPAcctIndex | int | NO | ||
| SyStudentID | int | YES | ||
| Type | char(3) | YES | ||
| saMiscCashID | int | YES | ||
SaStudSubsidiaryTransID |
int | YES | ||
| GL_Entry | varchar(25) | YES | ||
| Period | smallint | YES | ||
| FiscalYear | varchar(5) | YES | ||
| ReleasedToVantage | bit | NO | ||
SaJournalEntryGrpid |
int | YES | ||
SaBankDepId |
int | YES | ||
| CostAccount | char(30) | YES | ||
| PayeeName | nvarchar(150) | YES | ||
| PayeeAddress | nvarchar(300) | YES | ||
| DRN | char(10) | YES |
| SaGLRelease Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SaGlRelease_SaStudSubsidiaryTransID_SaGlReleaseID_U_N_IDX | Index | SaStudSubsidiaryTransID, SaGLReleaseID |
| SaGLRelease_SaGLReleaseID_U_C_IDX | PrimaryKey | SaGLReleaseID |
| SaGLRelease Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| SaBankDep | Non-Identifying | Zero or One to Zero or More | FK_SaGLRelease_SaBankDepId_SaBankDep_SaBankDepId | SaBankDepId | NO | YES | ||
| SaJournalEntryGrp | Non-Identifying | Zero or One to Zero or More | FK_SaGLRelease_SaJournalEntryGrpId_SaJournalEntryGrp_SaJournalEntryGrpId | SaJournalEntryGrpid | NO | YES | ||
| SaStudSubsidiaryTrans | Non-Identifying | Zero or One to Zero or More | Fk_SaGlRelease_SaStudSubsidiaryTrans_SaStudSubsidiaryTrans_SaStudSubsidiaryTransID | SaStudSubsidiaryTransID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaGLRelease Check Constraints |
| Check Constraint Name | CheckConstraint |